package com.xinbochuang.machine.admin.mapper.macRoom;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xinbochuang.machine.admin.domain.macRoom.Ulocation;
import com.xinbochuang.machine.admin.domain.macRoom.UlocationCount;
import com.xinbochuang.machine.admin.domain.macRoom.UlocationMacRoomStatic;
import com.xinbochuang.machine.admin.domain.macRoom.UlocationStatic;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author 杜文博
 * @date 2020-09-08
 */
public interface UlocationMapper extends BaseMapper<Ulocation> {

    int deleteUlocationByCabinetId(String CabinetId);

    List<UlocationStatic> getUlocationStatic(@Param("macId") String macId, @Param("macName") String macName, @Param("cabinetName") String cabinetName, @Param("ulocationHeight") Integer ulocationHeight, @Param("deptId") String deptId);

    List<UlocationMacRoomStatic> getUlocationStaticNew(@Param("deptId") String deptId, @Param("macName") String macName, @Param("ulocationHeight") Integer ulocationHeight);

    /**
     * 机房u位统计
     *
     * @param deptIds 权限
     * @return 结果
     */
    List<UlocationCount> selectUlocationCount(@Param("deptIds") Integer deptIds);
}
